0a ›(ĨOBJECTIDIPARENTIDIOBJECTTYPEC OBJECTNAMEC€PROPERTYM“CODEM—RIINFOC›USERMĄ Database Database  Database TransactionLog Database StoredProceduresSource Database StoredProceduresObject Database StoredProceduresDependencies Table clients Field clientid Field companyname  Field address  Field city  Field stateorprovince $ Field postalcode * Field country 0 Field contactfirstname 6 Field contactlastname < Field contacttitle B Field phonenumber H Field faxnumber N Field referredby T Field notes Z Table employees ^ Field employeeid a Field employeenumber g Field firstname m Field lastname s Field title y Field emailname  Field extension … Field address ‹ Field city ‘ Field stateorprovince — Field postalcode  !Field country Ģ "Field homephone Đ #Field workphone Ŋ $Field billingrate ĩ %Table expense_codes đ &%Field expensecodeid ž '%Field expensecode  (Table my_company_information › )(Field setupid É *(Field companyname Î +(Field address Ō ,(Field city Û -(Field stateorprovince ß .(Field postalcode į /(Field country ë 0(Field phonenumber ó 1(Field faxnumber ũ 2(Field defaultpaymentterms ĸ 3(Field defaultinvoicedescription  4Table payment_methods Í 54Field paymentmethodid  64Field paymentmethod  74Field creditcard  8Table payments Č 98Field paymentid  :8Field projectid # ;8Field paymentamount + <8Field paymentdate / =8Field creditcardnumber 7 >8Field cardholdersname ; ?8Field creditcardexpdate C @8Field creditcardauthorizationnumber G A8Field paymentmethodid O BTable projects Į CBField projectid S DBField projectname [ EBField projectdescription _ FBField clientid g GBField purchaseordernumber k HBField projecttotalbillingestimate s IBField employeeid w JBField projectbegindate  KBField projectenddate ƒ LTable time_card_expenses Æ MLField timecardexpenseid  NLField timecardid ‘ OLField expensedate ™ PLField projectid  QLField expensedescription Ą RLField expenseamount • SLField expensecodeid { TTable time_card_hours Á UTField timecarddetailid o VTField timecardid c WTField dateworked W XTField projectid K YTField workdescription ? ZTField billablehours 3 [TField billingrate ' \TField workcodeid  ]Table time_cards Ā ^]Field timecardid  _]Field employeeid  `]Field dateentered û aTable work_codes ŧ baField workcodeid ï caField workcode ã dIndex primarykey š eIndex companynam ī fIndex postalcode ģ gIndex primarykey Ū hIndex lastname ­ iIndex emailname Ļ jIndex postalcode § k%Index primarykey Ē l(Index primarykey Ą m(Index postalcode – n4Index primarykey • o8Index primarykey  pBIndex primarykey  qBIndex projectnam Š rLIndex primarykey ‰ sTIndex primarykey „ tTIndex dateworked ƒ u]Index primarykey ~ vaIndex primarykey } wBIndex clientid x xBRelation Relation 1 w yBIndex employeeid r zBRelation Relation 2 q {]Index employeeid l |]Relation Relation 1 k }LIndex expensecod ` ~LRelation Relation 1 e 8Index paymentmet _ €8Relation Relation 1 X 8Index projectid S ‚8Relation Relation 2 R ƒLIndex projectid M „LRelation Relation 2 L …TIndex projectid G †TRelation Relation 1 F ‡LIndex timecardid A ˆLRelation Relation 3 @ ‰TIndex timecardid ; ŠTRelation Relation 2 : ‹TIndex workcodeid 5 ŒTRelation Relation 3 4 View expenses by project ­ ŽField projectid . Field total_expenses ) Index lastname ( ‘(Index compname  ’View expenses by project for date range Ĩ “’Field projectid " ”’Field total_expenses  •View hours by project ‡ –•Field projectid  —•Field total_hours  ˜•Field billing_amount  ™View sum of payments Ö š™Field projectid ›™Field total_payments